package com.tssm.pojo;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

/**
 * SarcInvestigation entity. @author MyEclipse Persistence Tools
 */
@Entity
@Table(name = "SARC_INVESTIGATION", schema = "dbo", catalog = "ts")
public class SarcInvestigation implements java.io.Serializable {

	// Fields

	private Long investigationid;
	private Long supplierid;
	private String code;
	private Date investigationTime;
	private String type;
	private String qualification;
	private String address;
	private String postcode;
	private String portal;
	private String pushType;
	private String payType;
	private Double imprest;
	private Long settlement;
	private String currency;
	private String transportType;
	private String legalPerson;
	private String contact;
	private String tel;
	private String fax;
	private String mobile;
	private String email;
	private String bank;
	private String bankAccount;
	private String taxCollector;
	private String property;
	private Double registerCapital;
	private Double fixedAssets;
	private Long employee;
	private Long management;
	private Long technical;
	private Long qc;
	private String groupOutput;
	private String supplyAbility;
	private String process;
	private String productionEquipment;
	private String detectionEquipment;
	private String getApprove;
	private String planApprove;
	private String approveStandard;
	private String approveReport;
	private Byte ifPushPurchasing;
	private Byte auditState;
	private Date auditTime;
	private String auditPerson;
	private String taxationCert;
	private Date taxationEndtime;
	private String businessCert;
	private Date businessEndtime;
	private String productCert;
	private Date productEndtime;
	private String operateCert;
	private Date operateEndtime;
	private String tdsCert;
	private Date tdsEndtime;
	private String msdsCert;
	private Date msdsEndtime;
	private String otherCert;
	private Date otherEndtime;
	private Date addTime;
	private Date modifyTime;
	private Date finishTime;
	private String def1;
	private String def2;
	private String def3;
	private String def4;
	private String def5;
	private String def6;
	private String def7;
	private String def8;
	private String def9;
	private Date ts;
	private Long dr;
	private Long deptid;
	private Long operatorid;
	private String status;

	// Constructors

	/** default constructor */
	public SarcInvestigation() {
	}

	/** minimal constructor */
	public SarcInvestigation(Long investigationid) {
		this.investigationid = investigationid;
	}

	/** full constructor */
	public SarcInvestigation(Long investigationid, Long supplierid,
			String code, Date investigationTime, String type,
			String qualification, String address, String postcode,
			String portal, String pushType, String payType, Double imprest,
			Long settlement, String currency, String transportType,
			String legalPerson, String contact, String tel, String fax,
			String mobile, String email, String bank, String bankAccount,
			String taxCollector, String property, Double registerCapital,
			Double fixedAssets, Long employee, Long management, Long technical,
			Long qc, String groupOutput, String supplyAbility, String process,
			String productionEquipment, String detectionEquipment,
			String getApprove, String planApprove, String approveStandard,
			String approveReport, Byte ifPushPurchasing, Byte auditState,
			Date auditTime, String auditPerson, String taxationCert,
			Date taxationEndtime, String businessCert,
			Date businessEndtime, String productCert,
			Date productEndtime, String operateCert,
			Date operateEndtime, String tdsCert, Date tdsEndtime,
			String msdsCert, Date msdsEndtime, String otherCert,
			Date otherEndtime, Date addTime, Date modifyTime,
			Date finishTime, String def1, String def2, String def3,
			String def4, String def5, String def6, String def7, String def8,
			String def9, Date ts, Long dr, Long deptid, Long operatorid,
			String status) {
		this.investigationid = investigationid;
		this.supplierid = supplierid;
		this.code = code;
		this.investigationTime = investigationTime;
		this.type = type;
		this.qualification = qualification;
		this.address = address;
		this.postcode = postcode;
		this.portal = portal;
		this.pushType = pushType;
		this.payType = payType;
		this.imprest = imprest;
		this.settlement = settlement;
		this.currency = currency;
		this.transportType = transportType;
		this.legalPerson = legalPerson;
		this.contact = contact;
		this.tel = tel;
		this.fax = fax;
		this.mobile = mobile;
		this.email = email;
		this.bank = bank;
		this.bankAccount = bankAccount;
		this.taxCollector = taxCollector;
		this.property = property;
		this.registerCapital = registerCapital;
		this.fixedAssets = fixedAssets;
		this.employee = employee;
		this.management = management;
		this.technical = technical;
		this.qc = qc;
		this.groupOutput = groupOutput;
		this.supplyAbility = supplyAbility;
		this.process = process;
		this.productionEquipment = productionEquipment;
		this.detectionEquipment = detectionEquipment;
		this.getApprove = getApprove;
		this.planApprove = planApprove;
		this.approveStandard = approveStandard;
		this.approveReport = approveReport;
		this.ifPushPurchasing = ifPushPurchasing;
		this.auditState = auditState;
		this.auditTime = auditTime;
		this.auditPerson = auditPerson;
		this.taxationCert = taxationCert;
		this.taxationEndtime = taxationEndtime;
		this.businessCert = businessCert;
		this.businessEndtime = businessEndtime;
		this.productCert = productCert;
		this.productEndtime = productEndtime;
		this.operateCert = operateCert;
		this.operateEndtime = operateEndtime;
		this.tdsCert = tdsCert;
		this.tdsEndtime = tdsEndtime;
		this.msdsCert = msdsCert;
		this.msdsEndtime = msdsEndtime;
		this.otherCert = otherCert;
		this.otherEndtime = otherEndtime;
		this.addTime = addTime;
		this.modifyTime = modifyTime;
		this.finishTime = finishTime;
		this.def1 = def1;
		this.def2 = def2;
		this.def3 = def3;
		this.def4 = def4;
		this.def5 = def5;
		this.def6 = def6;
		this.def7 = def7;
		this.def8 = def8;
		this.def9 = def9;
		this.ts = ts;
		this.dr = dr;
		this.deptid = deptid;
		this.operatorid = operatorid;
		this.status = status;
	}

	// Property accessors
	@Id
	@GeneratedValue
	@Column(name = "INVESTIGATIONID", unique = true, nullable = false, precision = 18, scale = 0)
	public Long getInvestigationid() {
		return this.investigationid;
	}

	public void setInvestigationid(Long investigationid) {
		this.investigationid = investigationid;
	}

	@Column(name = "SUPPLIERID", precision = 18, scale = 0)
	public Long getSupplierid() {
		return this.supplierid;
	}

	public void setSupplierid(Long supplierid) {
		this.supplierid = supplierid;
	}

	@Column(name = "CODE")
	public String getCode() {
		return this.code;
	}

	public void setCode(String code) {
		this.code = code;
	}

	@Column(name = "INVESTIGATION_TIME", length = 23)
	public Date getInvestigationTime() {
		return this.investigationTime;
	}

	public void setInvestigationTime(Date investigationTime) {
		this.investigationTime = investigationTime;
	}

	@Column(name = "TYPE")
	public String getType() {
		return this.type;
	}

	public void setType(String type) {
		this.type = type;
	}

	@Column(name = "QUALIFICATION")
	public String getQualification() {
		return this.qualification;
	}

	public void setQualification(String qualification) {
		this.qualification = qualification;
	}

	@Column(name = "ADDRESS")
	public String getAddress() {
		return this.address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	@Column(name = "POSTCODE")
	public String getPostcode() {
		return this.postcode;
	}

	public void setPostcode(String postcode) {
		this.postcode = postcode;
	}

	@Column(name = "PORTAL")
	public String getPortal() {
		return this.portal;
	}

	public void setPortal(String portal) {
		this.portal = portal;
	}

	@Column(name = "PUSH_TYPE")
	public String getPushType() {
		return this.pushType;
	}

	public void setPushType(String pushType) {
		this.pushType = pushType;
	}

	@Column(name = "PAY_TYPE")
	public String getPayType() {
		return this.payType;
	}

	public void setPayType(String payType) {
		this.payType = payType;
	}

	@Column(name = "IMPREST", precision = 18)
	public Double getImprest() {
		return this.imprest;
	}

	public void setImprest(Double imprest) {
		this.imprest = imprest;
	}

	@Column(name = "SETTLEMENT", precision = 18, scale = 0)
	public Long getSettlement() {
		return this.settlement;
	}

	public void setSettlement(Long settlement) {
		this.settlement = settlement;
	}

	@Column(name = "CURRENCY")
	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	@Column(name = "TRANSPORT_TYPE")
	public String getTransportType() {
		return this.transportType;
	}

	public void setTransportType(String transportType) {
		this.transportType = transportType;
	}

	@Column(name = "LEGAL_PERSON")
	public String getLegalPerson() {
		return this.legalPerson;
	}

	public void setLegalPerson(String legalPerson) {
		this.legalPerson = legalPerson;
	}

	@Column(name = "CONTACT")
	public String getContact() {
		return this.contact;
	}

	public void setContact(String contact) {
		this.contact = contact;
	}

	@Column(name = "TEL")
	public String getTel() {
		return this.tel;
	}

	public void setTel(String tel) {
		this.tel = tel;
	}

	@Column(name = "FAX")
	public String getFax() {
		return this.fax;
	}

	public void setFax(String fax) {
		this.fax = fax;
	}

	@Column(name = "MOBILE")
	public String getMobile() {
		return this.mobile;
	}

	public void setMobile(String mobile) {
		this.mobile = mobile;
	}

	@Column(name = "EMAIL")
	public String getEmail() {
		return this.email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	@Column(name = "BANK")
	public String getBank() {
		return this.bank;
	}

	public void setBank(String bank) {
		this.bank = bank;
	}

	@Column(name = "BANK_ACCOUNT")
	public String getBankAccount() {
		return this.bankAccount;
	}

	public void setBankAccount(String bankAccount) {
		this.bankAccount = bankAccount;
	}

	@Column(name = "TAX_COLLECTOR")
	public String getTaxCollector() {
		return this.taxCollector;
	}

	public void setTaxCollector(String taxCollector) {
		this.taxCollector = taxCollector;
	}

	@Column(name = "PROPERTY")
	public String getProperty() {
		return this.property;
	}

	public void setProperty(String property) {
		this.property = property;
	}

	@Column(name = "REGISTER_CAPITAL", precision = 18)
	public Double getRegisterCapital() {
		return this.registerCapital;
	}

	public void setRegisterCapital(Double registerCapital) {
		this.registerCapital = registerCapital;
	}

	@Column(name = "FIXED_ASSETS", precision = 18)
	public Double getFixedAssets() {
		return this.fixedAssets;
	}

	public void setFixedAssets(Double fixedAssets) {
		this.fixedAssets = fixedAssets;
	}

	@Column(name = "EMPLOYEE", precision = 18, scale = 0)
	public Long getEmployee() {
		return this.employee;
	}

	public void setEmployee(Long employee) {
		this.employee = employee;
	}

	@Column(name = "MANAGEMENT", precision = 18, scale = 0)
	public Long getManagement() {
		return this.management;
	}

	public void setManagement(Long management) {
		this.management = management;
	}

	@Column(name = "TECHNICAL", precision = 18, scale = 0)
	public Long getTechnical() {
		return this.technical;
	}

	public void setTechnical(Long technical) {
		this.technical = technical;
	}

	@Column(name = "QC", precision = 18, scale = 0)
	public Long getQc() {
		return this.qc;
	}

	public void setQc(Long qc) {
		this.qc = qc;
	}

	@Column(name = "GROUP_OUTPUT")
	public String getGroupOutput() {
		return this.groupOutput;
	}

	public void setGroupOutput(String groupOutput) {
		this.groupOutput = groupOutput;
	}

	@Column(name = "SUPPLY_ABILITY")
	public String getSupplyAbility() {
		return this.supplyAbility;
	}

	public void setSupplyAbility(String supplyAbility) {
		this.supplyAbility = supplyAbility;
	}

	@Column(name = "PROCESS")
	public String getProcess() {
		return this.process;
	}

	public void setProcess(String process) {
		this.process = process;
	}

	@Column(name = "PRODUCTION_EQUIPMENT")
	public String getProductionEquipment() {
		return this.productionEquipment;
	}

	public void setProductionEquipment(String productionEquipment) {
		this.productionEquipment = productionEquipment;
	}

	@Column(name = "DETECTION_EQUIPMENT")
	public String getDetectionEquipment() {
		return this.detectionEquipment;
	}

	public void setDetectionEquipment(String detectionEquipment) {
		this.detectionEquipment = detectionEquipment;
	}

	@Column(name = "GET_APPROVE")
	public String getGetApprove() {
		return this.getApprove;
	}

	public void setGetApprove(String getApprove) {
		this.getApprove = getApprove;
	}

	@Column(name = "PLAN_APPROVE")
	public String getPlanApprove() {
		return this.planApprove;
	}

	public void setPlanApprove(String planApprove) {
		this.planApprove = planApprove;
	}

	@Column(name = "APPROVE_STANDARD", length = 500)
	public String getApproveStandard() {
		return this.approveStandard;
	}

	public void setApproveStandard(String approveStandard) {
		this.approveStandard = approveStandard;
	}

	@Column(name = "APPROVE_REPORT", length = 1000)
	public String getApproveReport() {
		return this.approveReport;
	}

	public void setApproveReport(String approveReport) {
		this.approveReport = approveReport;
	}

	@Column(name = "IF_PUSH_PURCHASING", precision = 2, scale = 0)
	public Byte getIfPushPurchasing() {
		return this.ifPushPurchasing;
	}

	public void setIfPushPurchasing(Byte ifPushPurchasing) {
		this.ifPushPurchasing = ifPushPurchasing;
	}

	@Column(name = "AUDIT_STATE", precision = 2, scale = 0)
	public Byte getAuditState() {
		return this.auditState;
	}

	public void setAuditState(Byte auditState) {
		this.auditState = auditState;
	}

	@Column(name = "AUDIT_TIME", length = 23)
	public Date getAuditTime() {
		return this.auditTime;
	}

	public void setAuditTime(Date auditTime) {
		this.auditTime = auditTime;
	}

	@Column(name = "AUDIT_PERSON")
	public String getAuditPerson() {
		return this.auditPerson;
	}

	public void setAuditPerson(String auditPerson) {
		this.auditPerson = auditPerson;
	}

	@Column(name = "TAXATION_CERT")
	public String getTaxationCert() {
		return this.taxationCert;
	}

	public void setTaxationCert(String taxationCert) {
		this.taxationCert = taxationCert;
	}

	@Column(name = "TAXATION_ENDTIME", length = 23)
	public Date getTaxationEndtime() {
		return this.taxationEndtime;
	}

	public void setTaxationEndtime(Date taxationEndtime) {
		this.taxationEndtime = taxationEndtime;
	}

	@Column(name = "BUSINESS_CERT")
	public String getBusinessCert() {
		return this.businessCert;
	}

	public void setBusinessCert(String businessCert) {
		this.businessCert = businessCert;
	}

	@Column(name = "BUSINESS_ENDTIME", length = 23)
	public Date getBusinessEndtime() {
		return this.businessEndtime;
	}

	public void setBusinessEndtime(Date businessEndtime) {
		this.businessEndtime = businessEndtime;
	}

	@Column(name = "PRODUCT_CERT")
	public String getProductCert() {
		return this.productCert;
	}

	public void setProductCert(String productCert) {
		this.productCert = productCert;
	}

	@Column(name = "PRODUCT_ENDTIME", length = 23)
	public Date getProductEndtime() {
		return this.productEndtime;
	}

	public void setProductEndtime(Date productEndtime) {
		this.productEndtime = productEndtime;
	}

	@Column(name = "OPERATE_CERT")
	public String getOperateCert() {
		return this.operateCert;
	}

	public void setOperateCert(String operateCert) {
		this.operateCert = operateCert;
	}

	@Column(name = "OPERATE_ENDTIME", length = 23)
	public Date getOperateEndtime() {
		return this.operateEndtime;
	}

	public void setOperateEndtime(Date operateEndtime) {
		this.operateEndtime = operateEndtime;
	}

	@Column(name = "TDS_CERT")
	public String getTdsCert() {
		return this.tdsCert;
	}

	public void setTdsCert(String tdsCert) {
		this.tdsCert = tdsCert;
	}

	@Column(name = "TDS_ENDTIME", length = 23)
	public Date getTdsEndtime() {
		return this.tdsEndtime;
	}

	public void setTdsEndtime(Date tdsEndtime) {
		this.tdsEndtime = tdsEndtime;
	}

	@Column(name = "MSDS_CERT")
	public String getMsdsCert() {
		return this.msdsCert;
	}

	public void setMsdsCert(String msdsCert) {
		this.msdsCert = msdsCert;
	}

	@Column(name = "MSDS_ENDTIME", length = 23)
	public Date getMsdsEndtime() {
		return this.msdsEndtime;
	}

	public void setMsdsEndtime(Date msdsEndtime) {
		this.msdsEndtime = msdsEndtime;
	}

	@Column(name = "OTHER_CERT")
	public String getOtherCert() {
		return this.otherCert;
	}

	public void setOtherCert(String otherCert) {
		this.otherCert = otherCert;
	}

	@Column(name = "OTHER_ENDTIME", length = 23)
	public Date getOtherEndtime() {
		return this.otherEndtime;
	}

	public void setOtherEndtime(Date otherEndtime) {
		this.otherEndtime = otherEndtime;
	}

	@Column(name = "ADD_TIME", length = 23)
	public Date getAddTime() {
		return this.addTime;
	}

	public void setAddTime(Date addTime) {
		this.addTime = addTime;
	}

	@Column(name = "MODIFY_TIME", length = 23)
	public Date getModifyTime() {
		return this.modifyTime;
	}

	public void setModifyTime(Date modifyTime) {
		this.modifyTime = modifyTime;
	}

	@Column(name = "FINISH_TIME", length = 23)
	public Date getFinishTime() {
		return this.finishTime;
	}

	public void setFinishTime(Date finishTime) {
		this.finishTime = finishTime;
	}

	@Column(name = "DEF1")
	public String getDef1() {
		return this.def1;
	}

	public void setDef1(String def1) {
		this.def1 = def1;
	}

	@Column(name = "DEF2")
	public String getDef2() {
		return this.def2;
	}

	public void setDef2(String def2) {
		this.def2 = def2;
	}

	@Column(name = "DEF3")
	public String getDef3() {
		return this.def3;
	}

	public void setDef3(String def3) {
		this.def3 = def3;
	}

	@Column(name = "DEF4")
	public String getDef4() {
		return this.def4;
	}

	public void setDef4(String def4) {
		this.def4 = def4;
	}

	@Column(name = "DEF5")
	public String getDef5() {
		return this.def5;
	}

	public void setDef5(String def5) {
		this.def5 = def5;
	}

	@Column(name = "DEF6")
	public String getDef6() {
		return this.def6;
	}

	public void setDef6(String def6) {
		this.def6 = def6;
	}

	@Column(name = "DEF7")
	public String getDef7() {
		return this.def7;
	}

	public void setDef7(String def7) {
		this.def7 = def7;
	}

	@Column(name = "DEF8")
	public String getDef8() {
		return this.def8;
	}

	public void setDef8(String def8) {
		this.def8 = def8;
	}

	@Column(name = "DEF9")
	public String getDef9() {
		return this.def9;
	}

	public void setDef9(String def9) {
		this.def9 = def9;
	}

	@Column(name = "TS", length = 23)
	public Date getTs() {
		return this.ts;
	}

	public void setTs(Date ts) {
		this.ts = ts;
	}

	@Column(name = "DR", precision = 18, scale = 0)
	public Long getDr() {
		return this.dr;
	}

	public void setDr(Long dr) {
		this.dr = dr;
	}

	@Column(name = "DEPTID", precision = 18, scale = 0)
	public Long getDeptid() {
		return this.deptid;
	}

	public void setDeptid(Long deptid) {
		this.deptid = deptid;
	}

	@Column(name = "OPERATORID", precision = 18, scale = 0)
	public Long getOperatorid() {
		return this.operatorid;
	}

	public void setOperatorid(Long operatorid) {
		this.operatorid = operatorid;
	}

	@Column(name = "STATUS")
	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

}